To analyze expenses and revenues of University of Connecticut (UConn) Athletic Department from 2015 to 2020 in light of recent budget cuts.
To determine any possible discrepencies in fund allocation between Men’s and Women’s teams.
To investigate trends of specific expenses by team and gender, and to determine areas of significant increase.
To determine any statistically significant relationship between revenue and expense categories in an effort to increase revenue.
Data was collected from 2015-2020 reports submitted to NCAA Membership Financial Reporting System by UConn. The reports were aquired through the UConn Public Records Office in accordance with The Freedom of Information Act, 5 U.S.C. § 552. Exploratory and Inferencial Analysis shown here was performed in RStudio using plotly, flexdashboard, MASS, formattable, ggcorrplot and ggplot2 packages.
Author: Magdalene Mlynek
Date: April 30, 2021
In accordance with Title IX, the proportion of male/female student athletes must be proportional to the representation in the overall student body of the university. In 2019, the unduplicated proportion of female student athletes was 49.369% (n=313) and that of male student athletes was 50.631%; in 2018, these percentages were 49.608% (n=316) and 50.392% (n=321) respectively; and in 2017, 48.457% (n=314) and 51.543% (n=334) respectively. The female proportion within the student body at UConn was 51%, 50.5%, and 50.1% in 2019, 2018 and 2017 respectively.
We would expect athletic teams that have both a men’s and women’s program, for example, Soccer, Ice Hockey and Track and Field, to be easily comparable and have a similar roster size. However, in 2019, the unduplicated proportion of female student athletes was 48.623% (n=159) and that of male athletes was 51.276% (n=168); in 2018, these percentages were 48.036% (n=159) and 51.964% (n=172) respectively and in 2017, 45.882% (n=156) and 54.118% (n=184) respectively.
Plots shown here illustrate the expenses allocated by gender. From 2015 to 2019, the spending within Women’s teams have slightly increased to about$22.6M in 2019 from $19M in 2015. Similarly, spending within Men’s teams have increased to $37.6M in 2019 from $31.3M in 2015. Spending not allocated by gender has slightly decreased from $21.7M in 2015 to $20.5M in 2019.
In FY 2019, Men’s teams accounted for nearly half (49.1%) of all department spending, while Women’s teams accounted for just over a quarter (27.6%). This percentage of expenses allocated to Men’s teams has increased +1.1% from 2018 to 2019 and +2.5% from 2019-2020. However, that of women’s teams increased +0.70% from 2018-2019 and decreased -0.4% in 2019 to 2020. In addition, UConn spent 1.74 times more per male athlete than per female atlete in 2020, 1.62 times more in 2019 and 1.703 times more back in 2015.
We should note that while it was expected that expenses would drop slightly in FY 2020 due to the cancellation of spring seasons beginning in March 2020 during the COVID-19 pandemic. However, Men’s teams expenses increased +$1M while Women’s teams expenses decreased by -$0.9M and expenses not allocated by gender decreased by -$2.2M.
The cost per player was found by dividing the total expenses for a single team by its roster size. The plots below show the cost per player within each team, and within Gender, including matched teams.Note that the Cost per Player by Gender plots on the right are averages across Men’s teams and Women’s teams. In 2019, the teams with the highest cost per player was Women’s Basketball and Men’s Basketball at $728.3K and $659.5K respectively. The teams with the lowest cost per player are Men’s Swimming and Diving and Women’s Rowing at $24.8K and $25.1K respectively. In addition, the cost per player by team within the Women’s and Men’s Basketball teams have been steadily increasing since 2015 and increased $206.071K (39.46%) and $224.01K (51.44%) respectively, from 2015 to 2019.The average cost of a female student athlete across all Women’s teams in 2019 was $118.92K and the average cost of a male student athlete across all Men’s teams $136.28K, meaning the average cost of a male student athlete is 1.146 times more than that of a female student-athlete. In 2020, the average cost per male student athlete increased to 1.236 times the cost of a female student athelete.
Similar to findings in the “Expenses by Gender” section, we see that from 2019 to 2020, the average cost per player within Women’s teams decreased ($2.225K, 1.5%) while the average cost per player within Men’s teams increased ($7.965K, 5.8%). Completing this same analysis across Men’s and Women’s teams matched by sport (i.e Men’s Soccer and Women’s Soccer), we find that the results are flipped, and the average cost of a female student athlete across only matched sports is greater than that of the average male student athlete. In 2020, the cost per player (across matched teams) was nearly equal, however in 2019, the average cost per player within Women’s teams was $12.247K more than that of matched Men’s teams.
It is important to investigate the profit made within the Athletics Department and individual teams, as large expenses are anticipated to have large returns. The plots below illustrate this difference between revenue and expenses, referred to as profit. Note that across nearly all sports and years (2015-2020), profit is negative, meaning that the expenses are greater than revenue.
Football has the greatest loss of profit of -$14.86M, -$13.27M and -$8.09M in 2020, 2019 and 2018 respectively. In addition, we find that UConn’s high profile and “money generating” sports (Football, Men’s Basketball, Women’s Basketball and Men’s Ice Hockey) have the highest loss of profit across all teams. When stratified by gender, the loss of profit in the Men’s teams is 76% higher than that of Women’s teams. When only analyzed across teams matched by gender, we see that in 2015, the loss of profit was much higher among Women’s teams than Men’s, hiwever since 2017, the loss of profit of Men’s teams has been higher than the loss of profit of Women’s teams.
In taking a closer look at the profit of the Athletic Department, below are plots showing the profit per player by team and within Men’s and Women’s teams. Again, note that profit is negative across nearly every year, team and gender. To compare the profit per player within Men’s versus Women’s teams, since 2015, Men’s teams have decreased -$72.578K (-273%) per player and the Women’s teams have decreased -$18.668K (-30%) per player. The largest loss of profit per player since 2015 is Women’s Basketball and saw -$318.081K in 2019 and -$388.151K per player in 2019 and 2020. Men’s Basketball had the largest decrease in profit per player with +$43.140K per player in 2015 and -$414.271K in 2020 (-1,060.3% decrease).
We should note that from 2015 to 2020, the five teams with the lowest average loss per player have consistently been Women’s Rowing, Men’s Swimming and Diving, Men’s Tennis, Men’s Track and Field and Women’s Track and Field. In 2019, the profit loss per player in Women’s Basketball was between 9.9 and 15.3 times more than that of each of these five teams.
Below are the correlations between revenue and various expense variables, to better understand any linear relationships between revenue and expenses, from 2015 to 2020 across all teams. Variables with many zeros were excluded.
Using the log(x+1) transformation of the response and a forward and backwards stepwise multiple linear regression model, the most appropriate model is the Model shown below which gives us the following mean multiplicative effects on revenue:
\(\hat{Revenue} = exp(9.696 +0.0154*(N.Scholarships) + (5.533e-07)*(SupportStaff) + (3.689e-06)*(Travel) + (3.778e-05)*(Memberships)\)
The interpretation of the statistically significant coefficients in the model are as follows. When Support Staff Expenses are increased by $100,000, we would expect an average 5.69% increase in revenue that year. Similarly, when Travel is increased by $10,000, we would expect to see a 3.76% increase in revenue on average. Lastly, as Memberships and Dues are increased (i.e. switching conferences), we would expect to see a 3.85% average increase in revenue.
From the F statistic for overall fit, we can reject the null hypothesis and conclude that the model has an adequate fit for the data. This model accounts for 71.64% of the variability in revenue. Additionally in the model fit plots, the residuals are approximately normal and there does not appear to be any significant concerns with the model performance.
To improve this analysis and given that many years of reporting data are availible, we should fit a time series model (i.e. ARIMA, VAR) to determine how expenses in year t impact the revenue in year t+1.
Call:
lm(formula = log(athletics$revenue + 1) ~ athletics$Equivalencies.Awarded +
athletics$Support.Staff.Expenses + athletics$Travel + athletics$Memberships.and.Dues,
data = athletics, na.action = na.omit)
Residuals:
Min 1Q Median 3Q Max
-9.8924 -0.6463 0.1519 0.7841 3.0034
Coefficients:
Estimate Std. Error t value Pr(>|t|)
(Intercept) 9.696e+00 1.955e-01 49.603 < 2e-16 ***
athletics$Equivalencies.Awarded 1.540e-02 9.472e-03 1.626 0.107
athletics$Support.Staff.Expenses 5.533e-07 5.321e-08 10.397 < 2e-16 ***
athletics$Travel 3.689e-06 3.383e-07 10.905 < 2e-16 ***
athletics$Memberships.and.Dues 3.778e-05 9.271e-06 4.075 8.26e-05 ***
---
Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
Residual standard error: 1.404 on 121 degrees of freedom
Multiple R-squared: 0.7255, Adjusted R-squared: 0.7164
F-statistic: 79.95 on 4 and 121 DF, p-value: < 2.2e-16